create table if not exists d_enp_ppm_dns_5m_#{PARTITION_DATE}
 (
dnspa01    datetime ,
dnspa02    datetime ,
dnspa03    varchar(128) ,
dnspa04    bigint ,
dnspa05    bigint ,
dnspa06    bigint ,
dnspa07    bigint ,
dnspa08    bigint ,
dnspa09    bigint ,
dnspa10    bigint ,
dnspa11    bigint ,
dnspa12    bigint ,
dnspa13    double ,
objectid    varchar(50) ,
objectname    varchar(50)
)   compress(5, 5)  nolock ;